﻿
create proc sp_xoatscd
@MaTSCD int
as
declare @dem as int
select @dem=count(*) from DanhMucTSCD where MaTSCD=@MaTSCD
if(@dem>0)
	begin
	delete DanhMucTSCD where MaTSCD=@MaTSCD
	select ErrCode=1
	end
else	
	begin
	select ErrCode=0
	end	